Dataset statistics
| Number of variables | 38 |
|---|---|
| Number of observations | 3240 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 822.8 KiB |
| Average record size in memory | 260.0 B |
Variable types
| Numeric | 24 |
|---|---|
| Categorical | 9 |
| DateTime | 5 |
msno has a high cardinality: 3240 distinct values | High cardinality |
bd is highly correlated with gender | High correlation |
gender is highly correlated with bd | High correlation |
total_payment_channels is highly correlated with total_transactions and 3 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan | High correlation |
payment_plan_days_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
change_in_plan is highly correlated with change_in_payment_methods | High correlation |
plan_list_price_mean is highly correlated with payment_plan_days_mean and 2 other fields | High correlation |
actual_amount_paid_mean is highly correlated with payment_plan_days_mean and 2 other fields | High correlation |
is_auto_renew_mean is highly correlated with is_autorenew_change_flag | High correlation |
is_autorenew_change_flag is highly correlated with is_auto_renew_mean | High correlation |
total_transactions is highly correlated with total_payment_channels and 3 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean | High correlation |
discount_mean is highly correlated with is_discount_mean and 1 other fields | High correlation |
is_discount_mean is highly correlated with discount_mean and 1 other fields | High correlation |
is_discount_max is highly correlated with discount_mean and 1 other fields | High correlation |
membership_duration_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_payment_channels and 2 other fields | High correlation |
num_25 is highly correlated with num_50 and 2 other fields | High correlation |
num_50 is highly correlated with num_25 and 2 other fields | High correlation |
num_75 is highly correlated with num_25 and 2 other fields | High correlation |
num_985 is highly correlated with num_25 and 2 other fields | High correlation |
num_100 is highly correlated with num_unq and 1 other fields | High correlation |
num_unq is highly correlated with num_100 and 1 other fields | High correlation |
total_secs is highly correlated with num_100 and 1 other fields | High correlation |
login_freq is highly correlated with total_payment_channels and 2 other fields | High correlation |
registration_duration is highly correlated with total_payment_channels and 3 other fields | High correlation |
bd is highly correlated with gender | High correlation |
gender is highly correlated with bd | High correlation |
total_payment_channels is highly correlated with total_transactions and 3 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan and 1 other fields | High correlation |
change_in_plan is highly correlated with change_in_payment_methods | High correlation |
plan_list_price_mean is highly correlated with actual_amount_paid_mean and 2 other fields | High correlation |
actual_amount_paid_mean is highly correlated with plan_list_price_mean and 2 other fields | High correlation |
is_auto_renew_mean is highly correlated with change_in_payment_methods and 3 other fields | High correlation |
is_autorenew_change_flag is highly correlated with is_auto_renew_mean | High correlation |
total_transactions is highly correlated with total_payment_channels and 3 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean | High correlation |
discount_mean is highly correlated with is_discount_mean and 1 other fields | High correlation |
is_discount_mean is highly correlated with discount_mean and 1 other fields | High correlation |
is_discount_max is highly correlated with discount_mean and 1 other fields | High correlation |
amt_per_day_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_payment_channels and 2 other fields | High correlation |
num_25 is highly correlated with num_50 and 2 other fields | High correlation |
num_50 is highly correlated with num_25 and 2 other fields | High correlation |
num_75 is highly correlated with num_25 and 2 other fields | High correlation |
num_985 is highly correlated with num_25 and 2 other fields | High correlation |
num_100 is highly correlated with num_unq and 1 other fields | High correlation |
num_unq is highly correlated with num_100 and 1 other fields | High correlation |
total_secs is highly correlated with num_100 and 1 other fields | High correlation |
login_freq is highly correlated with total_payment_channels and 2 other fields | High correlation |
registration_duration is highly correlated with total_payment_channels and 3 other fields | High correlation |
bd is highly correlated with gender | High correlation |
gender is highly correlated with bd | High correlation |
total_payment_channels is highly correlated with total_transactions and 2 other fields | High correlation |
change_in_payment_methods is highly correlated with change_in_plan and 1 other fields | High correlation |
change_in_plan is highly correlated with change_in_payment_methods | High correlation |
plan_list_price_mean is highly correlated with actual_amount_paid_mean and 2 other fields | High correlation |
actual_amount_paid_mean is highly correlated with plan_list_price_mean and 2 other fields | High correlation |
is_auto_renew_mean is highly correlated with change_in_payment_methods and 3 other fields | High correlation |
is_autorenew_change_flag is highly correlated with is_auto_renew_mean | High correlation |
total_transactions is highly correlated with total_payment_channels and 2 other fields | High correlation |
is_cancel_mean is highly correlated with is_cancel_change_flag | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean | High correlation |
discount_mean is highly correlated with is_discount_mean and 1 other fields | High correlation |
is_discount_mean is highly correlated with discount_mean and 1 other fields | High correlation |
is_discount_max is highly correlated with discount_mean and 1 other fields | High correlation |
amt_per_day_mean is highly correlated with plan_list_price_mean and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_payment_channels and 1 other fields | High correlation |
num_25 is highly correlated with num_50 | High correlation |
num_50 is highly correlated with num_25 and 1 other fields | High correlation |
num_75 is highly correlated with num_50 and 1 other fields | High correlation |
num_985 is highly correlated with num_75 | High correlation |
num_100 is highly correlated with num_unq and 1 other fields | High correlation |
num_unq is highly correlated with num_100 and 1 other fields | High correlation |
total_secs is highly correlated with num_100 and 1 other fields | High correlation |
registration_duration is highly correlated with total_payment_channels and 1 other fields | High correlation |
change_in_plan is highly correlated with total_transactions and 4 other fields | High correlation |
amt_per_day_mean is highly correlated with total_transactions and 11 other fields | High correlation |
city is highly correlated with bd and 2 other fields | High correlation |
total_transactions is highly correlated with change_in_plan and 5 other fields | High correlation |
is_autorenew_change_flag is highly correlated with is_churn and 3 other fields | High correlation |
is_churn is highly correlated with is_autorenew_change_flag and 1 other fields | High correlation |
bd is highly correlated with city and 2 other fields | High correlation |
is_auto_renew_mean is highly correlated with change_in_plan and 3 other fields | High correlation |
payment_plan_days_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
change_in_payment_methods is highly correlated with is_auto_renew_mean | High correlation |
total_payment_channels is highly correlated with change_in_plan and 5 other fields | High correlation |
num_985 is highly correlated with num_50 and 2 other fields | High correlation |
is_cancel_change_flag is highly correlated with is_cancel_mean and 1 other fields | High correlation |
is_cancel_mean is highly correlated with amt_per_day_mean and 3 other fields | High correlation |
num_50 is highly correlated with num_985 and 2 other fields | High correlation |
num_75 is highly correlated with num_985 and 3 other fields | High correlation |
is_discount_max is highly correlated with amt_per_day_mean and 3 other fields | High correlation |
membership_expire_date_max is highly correlated with amt_per_day_mean and 5 other fields | High correlation |
login_freq is highly correlated with total_transactions and 2 other fields | High correlation |
gender is highly correlated with amt_per_day_mean and 2 other fields | High correlation |
plan_list_price_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
registration_duration is highly correlated with change_in_plan and 5 other fields | High correlation |
is_discount_mean is highly correlated with amt_per_day_mean and 3 other fields | High correlation |
num_25 is highly correlated with num_985 and 3 other fields | High correlation |
total_secs is highly correlated with num_unq and 1 other fields | High correlation |
more_than_30_sum is highly correlated with total_transactions and 4 other fields | High correlation |
actual_amount_paid_mean is highly correlated with amt_per_day_mean and 4 other fields | High correlation |
num_unq is highly correlated with num_75 and 3 other fields | High correlation |
membership_duration_mean is highly correlated with payment_plan_days_mean and 2 other fields | High correlation |
discount_mean is highly correlated with amt_per_day_mean and 3 other fields | High correlation |
registered_via is highly correlated with change_in_plan and 6 other fields | High correlation |
num_100 is highly correlated with total_secs and 1 other fields | High correlation |
is_autorenew_change_flag is highly correlated with registered_via | High correlation |
registered_via is highly correlated with is_autorenew_change_flag | High correlation |
membership_duration_mean is highly skewed (γ1 = -31.16723676) | Skewed |
msno is uniformly distributed | Uniform |
df_index has unique values | Unique |
msno has unique values | Unique |
is_auto_renew_mean has 487 (15.0%) zeros | Zeros |
is_cancel_mean has 2770 (85.5%) zeros | Zeros |
discount_mean has 2911 (89.8%) zeros | Zeros |
is_discount_mean has 3026 (93.4%) zeros | Zeros |
more_than_30_sum has 428 (13.2%) zeros | Zeros |
num_25 has 134 (4.1%) zeros | Zeros |
num_50 has 556 (17.2%) zeros | Zeros |
num_75 has 844 (26.0%) zeros | Zeros |
num_985 has 815 (25.2%) zeros | Zeros |
num_100 has 41 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-19 10:59:18.921773 |
|---|---|
| Analysis finished | 2023-05-19 11:00:38.432253 |
| Duration | 1 minute and 19.51 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 3240 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 161888.8309 |
| Minimum | 14 |
|---|---|
| Maximum | 323987 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 15865.25 |
| Q1 | 80864.5 |
| median | 161963 |
| Q3 | 244588 |
| 95-th percentile | 307726.4 |
| Maximum | 323987 |
| Range | 323973 |
| Interquartile range (IQR) | 163723.5 |
Descriptive statistics
| Standard deviation | 94433.52726 |
|---|---|
| Coefficient of variation (CV) | 0.5833233013 |
| Kurtosis | -1.224760133 |
| Mean | 161888.8309 |
| Median Absolute Deviation (MAD) | 81636 |
| Skewness | 0.006914496358 |
| Sum | 524519812 |
| Variance | 8917691071 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 252737 | 1 | < 0.1% |
| 160338 | 1 | < 0.1% |
| 143945 | 1 | < 0.1% |
| 283395 | 1 | < 0.1% |
| 98262 | 1 | < 0.1% |
| 117828 | 1 | < 0.1% |
| 288532 | 1 | < 0.1% |
| 17270 | 1 | < 0.1% |
| 53987 | 1 | < 0.1% |
| 67522 | 1 | < 0.1% |
| Other values (3230) | 3230 |
| Value | Count | Frequency (%) |
| 14 | 1 | |
| 70 | 1 | |
| 123 | 1 | |
| 126 | 1 | |
| 183 | 1 | |
| 300 | 1 | |
| 316 | 1 | |
| 361 | 1 | |
| 393 | 1 | |
| 454 | 1 |
| Value | Count | Frequency (%) |
| 323987 | 1 | |
| 323798 | 1 | |
| 323743 | 1 | |
| 323717 | 1 | |
| 323665 | 1 | |
| 323461 | 1 | |
| 323388 | 1 | |
| 323370 | 1 | |
| 323348 | 1 | |
| 323329 | 1 |
| Distinct | 3240 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk= | 1 |
|---|---|
| oYyjgI3EMtpJamxLBTROcYLXR3spcB/4zXrqtTQFM74= | 1 |
| 6y0f6LY1AXh1qAI68f0faAKjgU/DPp+j63xTnsmdtT4= | 1 |
| hsR0Pfz3iJtzva17DoxOqq20i4WfYFKLN/wgT914vrI= | 1 |
| ZQbQiWQgoyPDP/cYkgDC0tCzFIjjBKIEEiU3/YGApMo= | 1 |
| Other values (3235) |
Length
| Max length | 44 |
|---|---|
| Median length | 44 |
| Mean length | 44 |
| Min length | 44 |
Characters and Unicode
| Total characters | 142560 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3240 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk= |
|---|---|
| 2nd row | 3twUh3ugQEnQyGAyOxT4uPhpMht2EPW1vl6/k7J+RdI= |
| 3rd row | /1X44AKG3S5AoBAJeokIkqLvgRaz+h5ElPncLqWnWys= |
| 4th row | 1Ufg2Ep/dzom8G0hN+0UWbmxpRPFrGt4D4Vh2yd4pOA= |
| 5th row | ZozytlgZZhHBVCTHGug8CxREhiV9QpS+TJ5e+z06gVA= |
Common Values
| Value | Count | Frequency (%) |
| T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk= | 1 | < 0.1% |
| oYyjgI3EMtpJamxLBTROcYLXR3spcB/4zXrqtTQFM74= | 1 | < 0.1% |
| 6y0f6LY1AXh1qAI68f0faAKjgU/DPp+j63xTnsmdtT4= | 1 | < 0.1% |
| hsR0Pfz3iJtzva17DoxOqq20i4WfYFKLN/wgT914vrI= | 1 | < 0.1% |
| ZQbQiWQgoyPDP/cYkgDC0tCzFIjjBKIEEiU3/YGApMo= | 1 | < 0.1% |
| E/+UHeBM49ngCPpd/Vaw/sYP6TaFVVdtzcUJ7gvMppc= | 1 | < 0.1% |
| Z3a78s0yd2RKBmzbbgZSL3hHHiFou4XHmgrto98NZu8= | 1 | < 0.1% |
| wiRcrrJmtHIk2yF1dRiDYq+EI9womxMzPoJuxEW/jys= | 1 | < 0.1% |
| qgeZDGVoBbyOgBRcWv9H8RoJ/XJTnSgoPw4+3Amuvx0= | 1 | < 0.1% |
| C0Pz1O2940qoI4iHBIdQdZtYdTKn9u/8kJy3AAGhESc= | 1 | < 0.1% |
| Other values (3230) | 3230 |
Length
| Value | Count | Frequency (%) |
| t4tle/joip0/bg9kokr3rd19xvzdihlvzvs3dhpweik | 1 | < 0.1% |
| oyyjgi3emtpjamxlbtrocylxr3spcb/4zxrqttqfm74 | 1 | < 0.1% |
| 6y0f6ly1axh1qai68f0faakjgu/dpp+j63xtnsmdtt4 | 1 | < 0.1% |
| hsr0pfz3ijtzva17doxoqq20i4wfyfkln/wgt914vri | 1 | < 0.1% |
| zqbqiwqgoypdp/cykgdc0tczfijjbkieeiu3/ygapmo | 1 | < 0.1% |
| e/+uhebm49ngcppd/vaw/syp6tafvvdtzcuj7gvmppc | 1 | < 0.1% |
| z3a78s0yd2rkbmzbbgzsl3hhhifou4xhmgrto98nzu8 | 1 | < 0.1% |
| wircrrjmthik2yf1dridyq+ei9womxmzpojuxew/jys | 1 | < 0.1% |
| qgezdgvobbyogbrcwv9h8roj/xjtnsgopw4+3amuvx0 | 1 | < 0.1% |
| c0pz1o2940qoi4ihbidqdztydtkn9u/8kjy3aaghesc | 1 | < 0.1% |
| Other values (3230) | 3230 |
Most occurring characters
| Value | Count | Frequency (%) |
| = | 3240 | 2.3% |
| I | 2427 | 1.7% |
| 0 | 2389 | 1.7% |
| A | 2370 | 1.7% |
| g | 2358 | 1.7% |
| s | 2351 | 1.6% |
| c | 2349 | 1.6% |
| 8 | 2335 | 1.6% |
| Q | 2333 | 1.6% |
| E | 2333 | 1.6% |
| Other values (55) | 118075 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 56582 | |
| Lowercase Letter | 56288 | |
| Decimal Number | 22086 | 15.5% |
| Math Symbol | 5462 | 3.8% |
| Other Punctuation | 2142 | 1.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 2427 | 4.3% |
| A | 2370 | 4.2% |
| Q | 2333 | 4.1% |
| E | 2333 | 4.1% |
| M | 2319 | 4.1% |
| Y | 2313 | 4.1% |
| U | 2252 | 4.0% |
| W | 2170 | 3.8% |
| Z | 2169 | 3.8% |
| H | 2158 | 3.8% |
| Other values (16) | 33738 |
Lowercase Letter
| Value | Count | Frequency (%) |
| g | 2358 | 4.2% |
| s | 2351 | 4.2% |
| c | 2349 | 4.2% |
| o | 2305 | 4.1% |
| w | 2294 | 4.1% |
| k | 2264 | 4.0% |
| m | 2225 | 4.0% |
| p | 2207 | 3.9% |
| b | 2167 | 3.8% |
| e | 2162 | 3.8% |
| Other values (16) | 33606 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2389 | |
| 8 | 2335 | |
| 4 | 2279 | |
| 5 | 2191 | |
| 2 | 2181 | |
| 6 | 2159 | |
| 3 | 2156 | |
| 9 | 2145 | |
| 1 | 2133 | |
| 7 | 2118 |
Math Symbol
| Value | Count | Frequency (%) |
| = | 3240 | |
| + | 2222 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2142 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 112870 | |
| Common | 29690 | 20.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 2427 | 2.2% |
| A | 2370 | 2.1% |
| g | 2358 | 2.1% |
| s | 2351 | 2.1% |
| c | 2349 | 2.1% |
| Q | 2333 | 2.1% |
| E | 2333 | 2.1% |
| M | 2319 | 2.1% |
| Y | 2313 | 2.0% |
| o | 2305 | 2.0% |
| Other values (42) | 89412 |
Common
| Value | Count | Frequency (%) |
| = | 3240 | |
| 0 | 2389 | 8.0% |
| 8 | 2335 | 7.9% |
| 4 | 2279 | 7.7% |
| + | 2222 | 7.5% |
| 5 | 2191 | 7.4% |
| 2 | 2181 | 7.3% |
| 6 | 2159 | 7.3% |
| 3 | 2156 | 7.3% |
| 9 | 2145 | 7.2% |
| Other values (3) | 6393 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 142560 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| = | 3240 | 2.3% |
| I | 2427 | 1.7% |
| 0 | 2389 | 1.7% |
| A | 2370 | 1.7% |
| g | 2358 | 1.7% |
| s | 2351 | 1.6% |
| c | 2349 | 1.6% |
| 8 | 2335 | 1.6% |
| Q | 2333 | 1.6% |
| E | 2333 | 1.6% |
| Other values (55) | 118075 |
| Distinct | 19 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.179012346 |
| Minimum | 1 |
|---|---|
| Maximum | 22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 5 |
| 95-th percentile | 17 |
| Maximum | 22 |
| Range | 21 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 5.782679871 |
|---|---|
| Coefficient of variation (CV) | 1.383743189 |
| Kurtosis | 1.974860602 |
| Mean | 4.179012346 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.773794867 |
| Sum | 13540 |
| Variance | 33.43938649 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2228 | |
| 13 | 203 | 6.3% |
| 5 | 179 | 5.5% |
| 4 | 131 | 4.0% |
| 22 | 119 | 3.7% |
| 15 | 109 | 3.4% |
| 6 | 55 | 1.7% |
| 14 | 54 | 1.7% |
| 11 | 21 | 0.6% |
| 18 | 21 | 0.6% |
| Other values (9) | 120 | 3.7% |
| Value | Count | Frequency (%) |
| 1 | 2228 | |
| 3 | 19 | 0.6% |
| 4 | 131 | 4.0% |
| 5 | 179 | 5.5% |
| 6 | 55 | 1.7% |
| 7 | 2 | 0.1% |
| 8 | 16 | 0.5% |
| 9 | 20 | 0.6% |
| 10 | 15 | 0.5% |
| 11 | 21 | 0.6% |
| Value | Count | Frequency (%) |
| 22 | 119 | |
| 21 | 17 | 0.5% |
| 18 | 21 | 0.6% |
| 17 | 8 | 0.2% |
| 16 | 2 | 0.1% |
| 15 | 109 | |
| 14 | 54 | 1.7% |
| 13 | 203 | |
| 12 | 21 | 0.6% |
| 11 | 21 | 0.6% |
| Distinct | 48 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.23395062 |
| Minimum | 6.3 |
|---|---|
| Maximum | 64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 6.3 |
|---|---|
| 5-th percentile | 6.3 |
| Q1 | 6.3 |
| median | 6.3 |
| Q3 | 19 |
| 95-th percentile | 34 |
| Maximum | 64 |
| Range | 57.7 |
| Interquartile range (IQR) | 12.7 |
Descriptive statistics
| Standard deviation | 10.34671505 |
|---|---|
| Coefficient of variation (CV) | 0.8457378466 |
| Kurtosis | 2.158231595 |
| Mean | 12.23395062 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.66947139 |
| Sum | 39638 |
| Variance | 107.0545123 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.3 | 2310 | |
| 22 | 67 | 2.1% |
| 21 | 58 | 1.8% |
| 27 | 57 | 1.8% |
| 20 | 57 | 1.8% |
| 25 | 55 | 1.7% |
| 24 | 54 | 1.7% |
| 23 | 53 | 1.6% |
| 26 | 51 | 1.6% |
| 19 | 48 | 1.5% |
| Other values (38) | 430 | 13.3% |
| Value | Count | Frequency (%) |
| 6.3 | 2310 | |
| 7 | 1 | < 0.1% |
| 14 | 2 | 0.1% |
| 15 | 3 | 0.1% |
| 16 | 9 | 0.3% |
| 17 | 34 | 1.0% |
| 18 | 44 | 1.4% |
| 19 | 48 | 1.5% |
| 20 | 57 | 1.8% |
| 21 | 58 | 1.8% |
| Value | Count | Frequency (%) |
| 64 | 1 | < 0.1% |
| 61 | 1 | < 0.1% |
| 58 | 1 | < 0.1% |
| 57 | 2 | 0.1% |
| 56 | 2 | 0.1% |
| 54 | 2 | 0.1% |
| 53 | 4 | |
| 52 | 5 | |
| 51 | 2 | 0.1% |
| 50 | 4 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 2 | |
|---|---|
| 0 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 2297 | |
| 0 | 502 | 15.5% |
| 1 | 441 | 13.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2 | 2297 | |
| 0 | 502 | 15.5% |
| 1 | 441 | 13.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 2297 | |
| 0 | 502 | 15.5% |
| 1 | 441 | 13.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2297 | |
| 0 | 502 | 15.5% |
| 1 | 441 | 13.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 2297 | |
| 0 | 502 | 15.5% |
| 1 | 441 | 13.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 2297 | |
| 0 | 502 | 15.5% |
| 1 | 441 | 13.6% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 7 | |
|---|---|
| 4 | |
| 9 | |
| 3 | |
| 13 | 26 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.008024691 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3266 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 3 |
| 3rd row | 7 |
| 4th row | 7 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 7 | 2085 | |
| 4 | 461 | 14.2% |
| 9 | 387 | 11.9% |
| 3 | 281 | 8.7% |
| 13 | 26 | 0.8% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 7 | 2085 | |
| 4 | 461 | 14.2% |
| 9 | 387 | 11.9% |
| 3 | 281 | 8.7% |
| 13 | 26 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 2085 | |
| 4 | 461 | 14.1% |
| 9 | 387 | 11.8% |
| 3 | 307 | 9.4% |
| 1 | 26 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3266 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 2085 | |
| 4 | 461 | 14.1% |
| 9 | 387 | 11.8% |
| 3 | 307 | 9.4% |
| 1 | 26 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3266 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 7 | 2085 | |
| 4 | 461 | 14.1% |
| 9 | 387 | 11.8% |
| 3 | 307 | 9.4% |
| 1 | 26 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3266 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 2085 | |
| 4 | 461 | 14.1% |
| 9 | 387 | 11.8% |
| 3 | 307 | 9.4% |
| 1 | 26 | 0.8% |
| Distinct | 729 |
|---|---|
| Distinct (%) | 22.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2017-02-07 00:00:00 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 0 | |
|---|---|
| 1 | 211 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 3029 | |
| 1 | 211 | 6.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 3029 | |
| 1 | 211 | 6.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3029 | |
| 1 | 211 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3029 | |
| 1 | 211 | 6.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 3029 | |
| 1 | 211 | 6.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 3029 | |
| 1 | 211 | 6.5% |
total_payment_channels
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 31 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.79444444 |
| Minimum | 1 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 7 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 36 |
| Range | 35 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.115061702 |
|---|---|
| Coefficient of variation (CV) | 0.5184696686 |
| Kurtosis | -0.7101382253 |
| Mean | 11.79444444 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2016205715 |
| Sum | 38214 |
| Variance | 37.39397962 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 212 | 6.5% |
| 17 | 207 | 6.4% |
| 14 | 207 | 6.4% |
| 9 | 201 | 6.2% |
| 13 | 176 | 5.4% |
| 16 | 175 | 5.4% |
| 7 | 173 | 5.3% |
| 3 | 167 | 5.2% |
| 18 | 162 | 5.0% |
| 12 | 157 | 4.8% |
| Other values (21) | 1403 |
| Value | Count | Frequency (%) |
| 1 | 38 | 1.2% |
| 2 | 120 | |
| 3 | 167 | |
| 4 | 147 | |
| 5 | 132 | |
| 6 | 139 | |
| 7 | 173 | |
| 8 | 212 | |
| 9 | 201 | |
| 10 | 133 |
| Value | Count | Frequency (%) |
| 36 | 1 | < 0.1% |
| 32 | 2 | 0.1% |
| 29 | 2 | 0.1% |
| 28 | 2 | 0.1% |
| 27 | 10 | 0.3% |
| 26 | 20 | |
| 25 | 24 | |
| 24 | 42 | |
| 23 | 39 | |
| 22 | 34 |
change_in_payment_methods
Categorical
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 67 |
| 4 | 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2843 | |
| 2 | 326 | 10.1% |
| 3 | 67 | 2.1% |
| 4 | 4 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 2843 | |
| 2 | 326 | 10.1% |
| 3 | 67 | 2.1% |
| 4 | 4 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2843 | |
| 2 | 326 | 10.1% |
| 3 | 67 | 2.1% |
| 4 | 4 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2843 | |
| 2 | 326 | 10.1% |
| 3 | 67 | 2.1% |
| 4 | 4 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 2843 | |
| 2 | 326 | 10.1% |
| 3 | 67 | 2.1% |
| 4 | 4 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 2843 | |
| 2 | 326 | 10.1% |
| 3 | 67 | 2.1% |
| 4 | 4 | 0.1% |
| Distinct | 190 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.6291838 |
| Minimum | 14.55555556 |
|---|---|
| Maximum | 450 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 14.55555556 |
|---|---|
| 5-th percentile | 28.63636364 |
| Q1 | 30 |
| median | 30 |
| Q3 | 30 |
| 95-th percentile | 35.16043956 |
| Maximum | 450 |
| Range | 435.4444444 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 28.03768047 |
|---|---|
| Coefficient of variation (CV) | 0.8337306262 |
| Kurtosis | 128.6321562 |
| Mean | 33.6291838 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.63379202 |
| Sum | 108958.5555 |
| Variance | 786.111526 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30 | 2783 | |
| 28.75 | 21 | 0.6% |
| 24.25 | 18 | 0.6% |
| 28.69565217 | 18 | 0.6% |
| 28.63636364 | 14 | 0.4% |
| 28.8 | 11 | 0.3% |
| 45 | 11 | 0.3% |
| 25.4 | 11 | 0.3% |
| 410 | 10 | 0.3% |
| 28.84615385 | 8 | 0.2% |
| Other values (180) | 335 | 10.3% |
| Value | Count | Frequency (%) |
| 14.55555556 | 1 | < 0.1% |
| 18.5 | 2 | 0.1% |
| 20.14285714 | 1 | < 0.1% |
| 20.8 | 1 | < 0.1% |
| 21.81818182 | 1 | < 0.1% |
| 22.17391304 | 3 | 0.1% |
| 22.33333333 | 5 | 0.2% |
| 23.18181818 | 2 | 0.1% |
| 24.25 | 18 | |
| 24.28571429 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 450 | 1 | < 0.1% |
| 410 | 10 | |
| 377.5 | 1 | < 0.1% |
| 265 | 1 | < 0.1% |
| 240 | 1 | < 0.1% |
| 220 | 2 | 0.1% |
| 205 | 1 | < 0.1% |
| 200 | 3 | 0.1% |
| 195 | 7 | |
| 180 | 3 | 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 1 | |
|---|---|
| 2 | |
| 3 | 72 |
| 4 | 5 |
| 5 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2818 | |
| 2 | 344 | 10.6% |
| 3 | 72 | 2.2% |
| 4 | 5 | 0.2% |
| 5 | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 2818 | |
| 2 | 344 | 10.6% |
| 3 | 72 | 2.2% |
| 4 | 5 | 0.2% |
| 5 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2818 | |
| 2 | 344 | 10.6% |
| 3 | 72 | 2.2% |
| 4 | 5 | 0.2% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2818 | |
| 2 | 344 | 10.6% |
| 3 | 72 | 2.2% |
| 4 | 5 | 0.2% |
| 5 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 2818 | |
| 2 | 344 | 10.6% |
| 3 | 72 | 2.2% |
| 4 | 5 | 0.2% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 2818 | |
| 2 | 344 | 10.6% |
| 3 | 72 | 2.2% |
| 4 | 5 | 0.2% |
| 5 | 1 | < 0.1% |
plan_list_price_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 474 |
|---|---|
| Distinct (%) | 14.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 139.228954 |
| Minimum | 0 |
|---|---|
| Maximum | 1788 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 99 |
| Q1 | 99 |
| median | 110.1304348 |
| Q3 | 149 |
| 95-th percentile | 180 |
| Maximum | 1788 |
| Range | 1788 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 119.4715099 |
|---|---|
| Coefficient of variation (CV) | 0.858093855 |
| Kurtosis | 122.3844121 |
| Mean | 139.228954 |
| Median Absolute Deviation (MAD) | 11.13043478 |
| Skewness | 10.04625679 |
| Sum | 451101.811 |
| Variance | 14273.44168 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 1502 | |
| 149 | 658 | |
| 180 | 148 | 4.6% |
| 129 | 50 | 1.5% |
| 100 | 30 | 0.9% |
| 142.7916667 | 22 | 0.7% |
| 143.04 | 13 | 0.4% |
| 142.2272727 | 11 | 0.3% |
| 111.75 | 11 | 0.3% |
| 150 | 11 | 0.3% |
| Other values (464) | 784 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 53.33333333 | 1 | |
| 74.5 | 1 | |
| 75 | 1 | |
| 85.14285714 | 1 | |
| 89.4 | 1 | |
| 90 | 1 | |
| 92.875 | 1 | |
| 93.17647059 | 1 | |
| 94 | 1 |
| Value | Count | Frequency (%) |
| 1788 | 10 | |
| 1399.5 | 1 | < 0.1% |
| 1132.5 | 1 | < 0.1% |
| 984 | 1 | < 0.1% |
| 958.5 | 1 | < 0.1% |
| 930 | 3 | 0.1% |
| 894 | 6 | |
| 799.5 | 1 | < 0.1% |
| 716 | 1 | < 0.1% |
| 695.3333333 | 1 | < 0.1% |
actual_amount_paid_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 492 |
|---|---|
| Distinct (%) | 15.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 138.4574094 |
| Minimum | 0 |
|---|---|
| Maximum | 1788 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 99 |
| Q1 | 99 |
| median | 102.3666667 |
| Q3 | 149 |
| 95-th percentile | 180 |
| Maximum | 1788 |
| Range | 1788 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 119.6452441 |
|---|---|
| Coefficient of variation (CV) | 0.8641303095 |
| Kurtosis | 121.8451475 |
| Mean | 138.4574094 |
| Median Absolute Deviation (MAD) | 12.58525641 |
| Skewness | 10.01005139 |
| Sum | 448602.0066 |
| Variance | 14314.98443 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 1502 | |
| 149 | 671 | |
| 180 | 147 | 4.5% |
| 129 | 51 | 1.6% |
| 100 | 30 | 0.9% |
| 111.75 | 14 | 0.4% |
| 150 | 11 | 0.3% |
| 132.4444444 | 11 | 0.3% |
| 1788 | 10 | 0.3% |
| 175 | 9 | 0.3% |
| Other values (482) | 784 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 49.66666667 | 1 | < 0.1% |
| 53.33333333 | 1 | < 0.1% |
| 59.6 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 64.5 | 1 | < 0.1% |
| 66 | 2 | 0.1% |
| 74.25 | 4 | |
| 74.5 | 5 | |
| 75 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1788 | 10 | |
| 1399.5 | 1 | < 0.1% |
| 1132.5 | 1 | < 0.1% |
| 984 | 1 | < 0.1% |
| 958.5 | 1 | < 0.1% |
| 930 | 3 | 0.1% |
| 894 | 6 | |
| 799.5 | 1 | < 0.1% |
| 716 | 1 | < 0.1% |
| 690 | 1 | < 0.1% |
is_auto_renew_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 78 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8247552119 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 487 |
| Zeros (%) | 15.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3631098106 |
|---|---|
| Coefficient of variation (CV) | 0.4402637356 |
| Kurtosis | 1.140655052 |
| Mean | 0.8247552119 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.734857511 |
| Sum | 2672.206887 |
| Variance | 0.1318487345 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2513 | |
| 0 | 487 | 15.0% |
| 0.75 | 20 | 0.6% |
| 0.6666666667 | 17 | 0.5% |
| 0.5 | 14 | 0.4% |
| 0.8888888889 | 10 | 0.3% |
| 0.8571428571 | 9 | 0.3% |
| 0.9 | 9 | 0.3% |
| 0.8 | 9 | 0.3% |
| 0.875 | 9 | 0.3% |
| Other values (68) | 143 | 4.4% |
| Value | Count | Frequency (%) |
| 0 | 487 | |
| 0.05 | 1 | < 0.1% |
| 0.08333333333 | 1 | < 0.1% |
| 0.1333333333 | 1 | < 0.1% |
| 0.1538461538 | 1 | < 0.1% |
| 0.1666666667 | 5 | 0.2% |
| 0.1818181818 | 1 | < 0.1% |
| 0.1875 | 1 | < 0.1% |
| 0.2 | 2 | 0.1% |
| 0.2142857143 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2513 | |
| 0.9583333333 | 1 | < 0.1% |
| 0.9545454545 | 1 | < 0.1% |
| 0.9523809524 | 1 | < 0.1% |
| 0.95 | 2 | 0.1% |
| 0.9473684211 | 2 | 0.1% |
| 0.9444444444 | 1 | < 0.1% |
| 0.9411764706 | 4 | 0.1% |
| 0.9375 | 3 | 0.1% |
| 0.9285714286 | 2 | 0.1% |
is_autorenew_change_flag
Categorical
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2753 | |
| 0 | 487 | 15.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 2753 | |
| 0 | 487 | 15.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2753 | |
| 0 | 487 | 15.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2753 | |
| 0 | 487 | 15.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 2753 | |
| 0 | 487 | 15.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 2753 | |
| 0 | 487 | 15.0% |
| Distinct | 721 |
|---|---|
| Distinct (%) | 22.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2017-02-17 00:00:00 |
| Distinct | 121 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| Minimum | 2015-11-24 00:00:00 |
|---|---|
| Maximum | 2017-02-28 00:00:00 |
total_transactions
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 31 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.79444444 |
| Minimum | 1 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 7 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 36 |
| Range | 35 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.115061702 |
|---|---|
| Coefficient of variation (CV) | 0.5184696686 |
| Kurtosis | -0.7101382253 |
| Mean | 11.79444444 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2016205715 |
| Sum | 38214 |
| Variance | 37.39397962 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 212 | 6.5% |
| 17 | 207 | 6.4% |
| 14 | 207 | 6.4% |
| 9 | 201 | 6.2% |
| 13 | 176 | 5.4% |
| 16 | 175 | 5.4% |
| 7 | 173 | 5.3% |
| 3 | 167 | 5.2% |
| 18 | 162 | 5.0% |
| 12 | 157 | 4.8% |
| Other values (21) | 1403 |
| Value | Count | Frequency (%) |
| 1 | 38 | 1.2% |
| 2 | 120 | |
| 3 | 167 | |
| 4 | 147 | |
| 5 | 132 | |
| 6 | 139 | |
| 7 | 173 | |
| 8 | 212 | |
| 9 | 201 | |
| 10 | 133 |
| Value | Count | Frequency (%) |
| 36 | 1 | < 0.1% |
| 32 | 2 | 0.1% |
| 29 | 2 | 0.1% |
| 28 | 2 | 0.1% |
| 27 | 10 | 0.3% |
| 26 | 20 | |
| 25 | 24 | |
| 24 | 42 | |
| 23 | 39 | |
| 22 | 34 |
| Distinct | 59 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| Minimum | 2017-02-01 00:00:00 |
|---|---|
| Maximum | 2017-03-31 00:00:00 |
is_cancel_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 46 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01397242557 |
| Minimum | 0 |
|---|---|
| Maximum | 0.5 |
| Zeros | 2770 |
| Zeros (%) | 85.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.09090909091 |
| Maximum | 0.5 |
| Range | 0.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.04222331276 |
|---|---|
| Coefficient of variation (CV) | 3.021902857 |
| Kurtosis | 26.4125793 |
| Mean | 0.01397242557 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.462107264 |
| Sum | 45.27065886 |
| Variance | 0.001782808141 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 0.05555555556 | 33 | 1.0% |
| 0.06666666667 | 33 | 1.0% |
| 0.07142857143 | 32 | 1.0% |
| 0.0625 | 26 | 0.8% |
| 0.05882352941 | 25 | 0.8% |
| 0.1111111111 | 23 | 0.7% |
| 0.09090909091 | 23 | 0.7% |
| 0.1 | 23 | 0.7% |
| 0.07692307692 | 22 | 0.7% |
| Other values (36) | 230 | 7.1% |
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 0.03448275862 | 1 | < 0.1% |
| 0.03571428571 | 1 | < 0.1% |
| 0.03703703704 | 6 | 0.2% |
| 0.03846153846 | 6 | 0.2% |
| 0.04 | 7 | 0.2% |
| 0.04166666667 | 6 | 0.2% |
| 0.04347826087 | 14 | 0.4% |
| 0.04545454545 | 5 | 0.2% |
| 0.04761904762 | 17 | 0.5% |
| Value | Count | Frequency (%) |
| 0.5 | 1 | < 0.1% |
| 0.4 | 2 | 0.1% |
| 0.3333333333 | 11 | |
| 0.2916666667 | 1 | < 0.1% |
| 0.25 | 11 | |
| 0.2380952381 | 1 | < 0.1% |
| 0.2222222222 | 2 | 0.1% |
| 0.2 | 11 | |
| 0.1818181818 | 1 | < 0.1% |
| 0.1666666667 | 20 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 1 | 470 | 14.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 1 | 470 | 14.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 1 | 470 | 14.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 1 | 470 | 14.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 1 | 470 | 14.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2770 | |
| 1 | 470 | 14.5% |
discount_mean
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 95 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7715445879 |
| Minimum | -223.5 |
|---|---|
| Maximum | 120 |
| Zeros | 2911 |
| Zeros (%) | 89.8% |
| Negative | 136 |
| Negative (%) | 4.2% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | -223.5 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 8.277777778 |
| Maximum | 120 |
| Range | 343.5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 8.732987399 |
|---|---|
| Coefficient of variation (CV) | 11.31883696 |
| Kurtosis | 220.6410199 |
| Mean | 0.7715445879 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -4.329118954 |
| Sum | 2499.804465 |
| Variance | 76.26506891 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2911 | |
| -6.208333333 | 18 | 0.6% |
| -5.96 | 15 | 0.5% |
| 18.625 | 14 | 0.4% |
| -6.47826087 | 13 | 0.4% |
| 16.55555556 | 13 | 0.4% |
| 14.9 | 10 | 0.3% |
| 24.83333333 | 9 | 0.3% |
| 9.3125 | 9 | 0.3% |
| 49.66666667 | 9 | 0.3% |
| Other values (85) | 219 | 6.8% |
| Value | Count | Frequency (%) |
| -223.5 | 1 | |
| -178.8 | 1 | |
| -40.63636364 | 1 | |
| -38.86956522 | 1 | |
| -37.56521739 | 2 | |
| -33.86363636 | 1 | |
| -32.95454545 | 1 | |
| -28.38095238 | 1 | |
| -22.35 | 2 | |
| -21.42857143 | 1 |
| Value | Count | Frequency (%) |
| 120 | 1 | < 0.1% |
| 99.33333333 | 1 | < 0.1% |
| 89.4 | 1 | < 0.1% |
| 74.5 | 5 | |
| 59.6 | 2 | 0.1% |
| 49.66666667 | 9 | |
| 42.57142857 | 1 | < 0.1% |
| 37.25 | 9 | |
| 35.05882353 | 1 | < 0.1% |
| 33.11111111 | 1 | < 0.1% |
is_discount_mean
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 48 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.009980551507 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 3026 |
| Zeros (%) | 93.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.05882352941 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.05208919576 |
|---|---|
| Coefficient of variation (CV) | 5.21906988 |
| Kurtosis | 100.3478214 |
| Mean | 0.009980551507 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.62887225 |
| Sum | 32.33698688 |
| Variance | 0.002713284315 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 0.125 | 14 | 0.4% |
| 0.1111111111 | 13 | 0.4% |
| 0.1 | 11 | 0.3% |
| 0.05263157895 | 10 | 0.3% |
| 0.0625 | 9 | 0.3% |
| 0.05555555556 | 9 | 0.3% |
| 0.2 | 9 | 0.3% |
| 0.25 | 9 | 0.3% |
| 0.3333333333 | 9 | 0.3% |
| Other values (38) | 121 | 3.7% |
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 0.03703703704 | 2 | 0.1% |
| 0.03846153846 | 4 | 0.1% |
| 0.04 | 1 | < 0.1% |
| 0.04166666667 | 5 | 0.2% |
| 0.04347826087 | 3 | 0.1% |
| 0.04545454545 | 5 | 0.2% |
| 0.04761904762 | 5 | 0.2% |
| 0.05 | 3 | 0.1% |
| 0.05263157895 | 10 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 0.7777777778 | 1 | < 0.1% |
| 0.6666666667 | 2 | 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.5294117647 | 1 | < 0.1% |
| 0.5 | 5 | |
| 0.4615384615 | 1 | < 0.1% |
| 0.4 | 2 | 0.1% |
| 0.3461538462 | 2 | 0.1% |
| 0.3333333333 | 9 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| 0 | |
|---|---|
| 1 | 214 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3240 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 1 | 214 | 6.6% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 1 | 214 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 1 | 214 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3240 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 1 | 214 | 6.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3240 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 1 | 214 | 6.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3240 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 3026 | |
| 1 | 214 | 6.6% |
| Distinct | 535 |
|---|---|
| Distinct (%) | 16.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.072860313 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.3 |
| Q1 | 3.3 |
| median | 3.333333333 |
| Q3 | 4.966666667 |
| 95-th percentile | 5.846153846 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 1.666666667 |
Descriptive statistics
| Standard deviation | 0.9099726283 |
|---|---|
| Coefficient of variation (CV) | 0.2234234809 |
| Kurtosis | -0.9085713907 |
| Mean | 4.072860313 |
| Median Absolute Deviation (MAD) | 0.3622222222 |
| Skewness | 0.455419139 |
| Sum | 13196.06741 |
| Variance | 0.8280501843 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.3 | 1318 | |
| 4.966666667 | 584 | |
| 3.3 | 184 | 5.7% |
| 6 | 147 | 4.5% |
| 4.3 | 51 | 1.6% |
| 3.333333333 | 31 | 1.0% |
| 4.759722222 | 19 | 0.6% |
| 3.725 | 14 | 0.4% |
| 5 | 12 | 0.4% |
| 4.414814815 | 12 | 0.4% |
| Other values (525) | 868 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1.324444444 | 1 | |
| 1.655555556 | 1 | |
| 1.777777778 | 1 | |
| 1.986666667 | 1 | |
| 1.9875 | 1 | |
| 1.99875 | 1 | |
| 2 | 1 | |
| 2.15 | 1 | |
| 2.180487805 | 1 |
| Value | Count | Frequency (%) |
| 6 | 147 | |
| 5.916666667 | 5 | 0.2% |
| 5.9 | 3 | 0.1% |
| 5.875 | 1 | < 0.1% |
| 5.852380952 | 2 | 0.1% |
| 5.850997783 | 1 | < 0.1% |
| 5.85 | 1 | < 0.1% |
| 5.846153846 | 4 | 0.1% |
| 5.833333333 | 9 | 0.3% |
| 5.830555556 | 1 | < 0.1% |
| Distinct | 729 |
|---|---|
| Distinct (%) | 22.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.58014865 |
| Minimum | -2395 |
|---|---|
| Maximum | 450 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | -2395 |
|---|---|
| 5-th percentile | 27.25 |
| Q1 | 29.82954545 |
| median | 30.3125 |
| Q3 | 30.41666667 |
| 95-th percentile | 45.87958333 |
| Maximum | 450 |
| Range | 2845 |
| Interquartile range (IQR) | 0.5871212121 |
Descriptive statistics
| Standard deviation | 51.21829634 |
|---|---|
| Coefficient of variation (CV) | 1.5252552 |
| Kurtosis | 1572.548189 |
| Mean | 33.58014865 |
| Median Absolute Deviation (MAD) | 0.3125 |
| Skewness | -31.16723676 |
| Sum | 108799.6816 |
| Variance | 2623.31388 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30 | 271 | 8.4% |
| 30.375 | 141 | 4.4% |
| 30.33333333 | 139 | 4.3% |
| 30.4 | 99 | 3.1% |
| 30.28571429 | 93 | 2.9% |
| 30.35714286 | 79 | 2.4% |
| 30.25 | 72 | 2.2% |
| 30.41176471 | 69 | 2.1% |
| 30.35294118 | 62 | 1.9% |
| 30.30769231 | 61 | 1.9% |
| Other values (719) | 2154 |
| Value | Count | Frequency (%) |
| -2395 | 1 | |
| 3 | 1 | |
| 6.333333333 | 1 | |
| 11.66666667 | 1 | |
| 12 | 1 | |
| 15 | 1 | |
| 15.5 | 1 | |
| 17.4 | 1 | |
| 18 | 1 | |
| 19 | 1 |
| Value | Count | Frequency (%) |
| 450 | 1 | < 0.1% |
| 434 | 1 | < 0.1% |
| 416 | 1 | < 0.1% |
| 413 | 4 | |
| 412 | 1 | < 0.1% |
| 411 | 1 | < 0.1% |
| 410 | 1 | < 0.1% |
| 380 | 2 | |
| 266 | 1 | < 0.1% |
| 221.5 | 1 | < 0.1% |
more_than_30_sum
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 25 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.60462963 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 428 |
| Zeros (%) | 13.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.146906008 |
|---|---|
| Coefficient of variation (CV) | 0.7399072342 |
| Kurtosis | -0.1578219444 |
| Mean | 5.60462963 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.4385603041 |
| Sum | 18159 |
| Variance | 17.19682944 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 428 | |
| 1 | 307 | |
| 9 | 301 | |
| 7 | 290 | |
| 5 | 268 | |
| 2 | 248 | |
| 10 | 234 | |
| 6 | 207 | 6.4% |
| 3 | 207 | 6.4% |
| 8 | 202 | 6.2% |
| Other values (15) | 548 |
| Value | Count | Frequency (%) |
| 0 | 428 | |
| 1 | 307 | |
| 2 | 248 | |
| 3 | 207 | |
| 4 | 171 | 5.3% |
| 5 | 268 | |
| 6 | 207 | |
| 7 | 290 | |
| 8 | 202 | |
| 9 | 301 |
| Value | Count | Frequency (%) |
| 24 | 1 | < 0.1% |
| 23 | 2 | 0.1% |
| 22 | 4 | |
| 21 | 2 | 0.1% |
| 20 | 2 | 0.1% |
| 19 | 5 | |
| 18 | 6 | |
| 17 | 8 | |
| 16 | 3 | 0.1% |
| 15 | 7 |
| Distinct | 2496 |
|---|---|
| Distinct (%) | 77.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.064854503 |
| Minimum | 0 |
|---|---|
| Maximum | 5.087596416 |
| Zeros | 134 |
| Zeros (%) | 4.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1155245304 |
| Q1 | 0.5493061543 |
| median | 0.9633517265 |
| Q3 | 1.469801635 |
| 95-th percentile | 2.369483924 |
| Maximum | 5.087596416 |
| Range | 5.087596416 |
| Interquartile range (IQR) | 0.9204954803 |
Descriptive statistics
| Standard deviation | 0.7031103969 |
|---|---|
| Coefficient of variation (CV) | 0.6602877378 |
| Kurtosis | 1.282059669 |
| Mean | 1.064854503 |
| Median Absolute Deviation (MAD) | 0.4530927241 |
| Skewness | 0.9175319672 |
| Sum | 3450.128662 |
| Variance | 0.4943642318 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 134 | 4.1% |
| 0.1732867956 | 53 | 1.6% |
| 0.3465735912 | 34 | 1.0% |
| 0.4479398727 | 22 | 0.7% |
| 0.2746530771 | 22 | 0.7% |
| 0.2310490608 | 19 | 0.6% |
| 0.6212266684 | 14 | 0.4% |
| 0.5493061543 | 13 | 0.4% |
| 0.794513464 | 12 | 0.4% |
| 0.5198603868 | 11 | 0.3% |
| Other values (2486) | 2906 |
| Value | Count | Frequency (%) |
| 0 | 134 | |
| 0.0433216989 | 4 | 0.1% |
| 0.05776226521 | 2 | 0.1% |
| 0.07701635361 | 2 | 0.1% |
| 0.08664339781 | 7 | 0.2% |
| 0.09155102819 | 3 | 0.1% |
| 0.09627044201 | 1 | < 0.1% |
| 0.099021025 | 1 | < 0.1% |
| 0.1005898714 | 1 | < 0.1% |
| 0.1032275632 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.087596416 | 1 | |
| 4.779123306 | 1 | |
| 4.668941021 | 1 | |
| 4.431880951 | 1 | |
| 4.094344616 | 1 | |
| 4.004874706 | 1 | |
| 3.934511423 | 1 | |
| 3.847038507 | 1 | |
| 3.739151239 | 1 | |
| 3.606147289 | 1 |
| Distinct | 1468 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3602947593 |
| Minimum | 0 |
|---|---|
| Maximum | 4.204692841 |
| Zeros | 556 |
| Zeros (%) | 17.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.08958797157 |
| median | 0.2735635042 |
| Q3 | 0.5163983405 |
| 95-th percentile | 1.069166541 |
| Maximum | 4.204692841 |
| Range | 4.204692841 |
| Interquartile range (IQR) | 0.4268103689 |
Descriptive statistics
| Standard deviation | 0.3708899021 |
|---|---|
| Coefficient of variation (CV) | 1.029406905 |
| Kurtosis | 8.441922188 |
| Mean | 0.3602947593 |
| Median Absolute Deviation (MAD) | 0.1988659501 |
| Skewness | 2.131618261 |
| Sum | 1167.35498 |
| Variance | 0.1375593096 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 556 | 17.2% |
| 0.1732867956 | 131 | 4.0% |
| 0.08664339781 | 67 | 2.1% |
| 0.3465735912 | 49 | 1.5% |
| 0.05776226521 | 48 | 1.5% |
| 0.2746530771 | 42 | 1.3% |
| 0.1155245304 | 35 | 1.1% |
| 0.2310490608 | 33 | 1.0% |
| 0.4479398727 | 30 | 0.9% |
| 0.3106133342 | 25 | 0.8% |
| Other values (1458) | 2224 |
| Value | Count | Frequency (%) |
| 0 | 556 | |
| 0.01575334556 | 1 | < 0.1% |
| 0.02166084945 | 2 | 0.1% |
| 0.02475525625 | 3 | 0.1% |
| 0.02567211725 | 1 | < 0.1% |
| 0.0266595073 | 1 | < 0.1% |
| 0.0271822419 | 1 | < 0.1% |
| 0.0288811326 | 2 | 0.1% |
| 0.03013683483 | 1 | < 0.1% |
| 0.03150669113 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.204692841 | 1 | |
| 2.833213329 | 1 | |
| 2.792538404 | 1 | |
| 2.77258873 | 1 | |
| 2.375086784 | 1 | |
| 2.28217411 | 1 | |
| 2.252919436 | 1 | |
| 2.197224617 | 1 | |
| 2.194118977 | 1 | |
| 2.193020582 | 1 |
| Distinct | 1060 |
|---|---|
| Distinct (%) | 32.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2255322188 |
| Minimum | 0 |
|---|---|
| Maximum | 2.302585125 |
| Zeros | 844 |
| Zeros (%) | 26.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1625835672 |
| Q3 | 0.3219796717 |
| 95-th percentile | 0.7225929499 |
| Maximum | 2.302585125 |
| Range | 2.302585125 |
| Interquartile range (IQR) | 0.3219796717 |
Descriptive statistics
| Standard deviation | 0.2635063827 |
|---|---|
| Coefficient of variation (CV) | 1.168375731 |
| Kurtosis | 8.076948166 |
| Mean | 0.2255322188 |
| Median Absolute Deviation (MAD) | 0.1625835598 |
| Skewness | 2.251515627 |
| Sum | 730.7243652 |
| Variance | 0.06943561882 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 844 | |
| 0.1732867956 | 142 | 4.4% |
| 0.08664339781 | 94 | 2.9% |
| 0.05776226521 | 63 | 1.9% |
| 0.2310490608 | 48 | 1.5% |
| 0.3465735912 | 44 | 1.4% |
| 0.1155245304 | 44 | 1.4% |
| 0.2746530771 | 31 | 1.0% |
| 0.1493132859 | 30 | 0.9% |
| 0.2239699364 | 30 | 0.9% |
| Other values (1050) | 1870 |
| Value | Count | Frequency (%) |
| 0 | 844 | |
| 0.01732867956 | 1 | < 0.1% |
| 0.0192540884 | 1 | < 0.1% |
| 0.01980420575 | 1 | < 0.1% |
| 0.02310490608 | 1 | < 0.1% |
| 0.02475525625 | 3 | 0.1% |
| 0.0266595073 | 1 | < 0.1% |
| 0.02772588655 | 1 | < 0.1% |
| 0.0288811326 | 8 | 0.2% |
| 0.03051700816 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.302585125 | 1 | |
| 2.197224617 | 1 | |
| 2.144054174 | 1 | |
| 1.945910215 | 1 | |
| 1.935600519 | 1 | |
| 1.912810326 | 1 | |
| 1.83605957 | 1 | |
| 1.791759491 | 1 | |
| 1.752498507 | 1 | |
| 1.66610229 | 1 |
| Distinct | 1082 |
|---|---|
| Distinct (%) | 33.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2363214344 |
| Minimum | 0 |
|---|---|
| Maximum | 2.224787235 |
| Zeros | 815 |
| Zeros (%) | 25.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1732867956 |
| Q3 | 0.3343475312 |
| 95-th percentile | 0.7880127043 |
| Maximum | 2.224787235 |
| Range | 2.224787235 |
| Interquartile range (IQR) | 0.3343475312 |
Descriptive statistics
| Standard deviation | 0.2739073336 |
|---|---|
| Coefficient of variation (CV) | 1.159045696 |
| Kurtosis | 6.389976501 |
| Mean | 0.2363214344 |
| Median Absolute Deviation (MAD) | 0.1629528999 |
| Skewness | 2.102514029 |
| Sum | 765.6814575 |
| Variance | 0.07502523065 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 815 | |
| 0.1732867956 | 152 | 4.7% |
| 0.08664339781 | 90 | 2.8% |
| 0.05776226521 | 60 | 1.9% |
| 0.1155245304 | 54 | 1.7% |
| 0.2746530771 | 45 | 1.4% |
| 0.2310490608 | 41 | 1.3% |
| 0.3465735912 | 40 | 1.2% |
| 0.1373265386 | 27 | 0.8% |
| 0.09155102819 | 23 | 0.7% |
| Other values (1072) | 1893 |
| Value | Count | Frequency (%) |
| 0 | 815 | |
| 0.01575334556 | 1 | < 0.1% |
| 0.01732867956 | 1 | < 0.1% |
| 0.0192540884 | 2 | 0.1% |
| 0.02166084945 | 3 | 0.1% |
| 0.02475525625 | 6 | 0.2% |
| 0.0288811326 | 11 | 0.3% |
| 0.03013683483 | 1 | < 0.1% |
| 0.03051700816 | 1 | < 0.1% |
| 0.03138892353 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2.224787235 | 1 | |
| 2.189838648 | 1 | |
| 2.020660639 | 1 | |
| 1.791759491 | 1 | |
| 1.754158974 | 1 | |
| 1.704551458 | 1 | |
| 1.695865512 | 1 | |
| 1.691724658 | 1 | |
| 1.678399086 | 1 | |
| 1.612094045 | 1 |
| Distinct | 3035 |
|---|---|
| Distinct (%) | 93.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.408321619 |
| Minimum | 0 |
|---|---|
| Maximum | 5.905887604 |
| Zeros | 41 |
| Zeros (%) | 1.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.8664339781 |
| Q1 | 1.884092122 |
| median | 2.439326286 |
| Q3 | 2.966488123 |
| 95-th percentile | 3.773670042 |
| Maximum | 5.905887604 |
| Range | 5.905887604 |
| Interquartile range (IQR) | 1.082396001 |
Descriptive statistics
| Standard deviation | 0.8759378195 |
|---|---|
| Coefficient of variation (CV) | 0.3637129664 |
| Kurtosis | 0.4219321609 |
| Mean | 2.408321619 |
| Median Absolute Deviation (MAD) | 0.5415901542 |
| Skewness | -0.139826104 |
| Sum | 7802.961914 |
| Variance | 0.767267108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 41 | 1.3% |
| 0.6931471825 | 12 | 0.4% |
| 0.3465735912 | 8 | 0.2% |
| 0.5198603868 | 7 | 0.2% |
| 2.079441547 | 6 | 0.2% |
| 0.8958797455 | 6 | 0.2% |
| 0.5493061543 | 5 | 0.2% |
| 0.8664339781 | 5 | 0.2% |
| 1.471526027 | 5 | 0.2% |
| 1.343819618 | 5 | 0.2% |
| Other values (3025) | 3140 |
| Value | Count | Frequency (%) |
| 0 | 41 | |
| 0.1373265386 | 1 | < 0.1% |
| 0.1732867956 | 4 | 0.1% |
| 0.2310490608 | 2 | 0.1% |
| 0.2484906614 | 1 | < 0.1% |
| 0.2746530771 | 3 | 0.1% |
| 0.2986265719 | 1 | < 0.1% |
| 0.3465735912 | 8 | 0.2% |
| 0.3662041128 | 2 | 0.1% |
| 0.3891820312 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.905887604 | 1 | |
| 5.331583023 | 1 | |
| 5.180026054 | 1 | |
| 5.068177223 | 1 | |
| 5.064611435 | 1 | |
| 5.061811447 | 1 | |
| 5.027421474 | 1 | |
| 5.01904726 | 1 | |
| 4.975762367 | 1 | |
| 4.912617207 | 1 |
| Distinct | 3107 |
|---|---|
| Distinct (%) | 95.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.625793695 |
| Minimum | 0 |
|---|---|
| Maximum | 5.407171726 |
| Zeros | 11 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 12.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.328061116 |
| Q1 | 2.183980525 |
| median | 2.661792874 |
| Q3 | 3.111875474 |
| 95-th percentile | 3.781433177 |
| Maximum | 5.407171726 |
| Range | 5.407171726 |
| Interquartile range (IQR) | 0.9278949499 |
Descriptive statistics
| Standard deviation | 0.7468746305 |
|---|---|
| Coefficient of variation (CV) | 0.2844376564 |
| Kurtosis | 0.7164651752 |
| Mean | 2.625793695 |
| Median Absolute Deviation (MAD) | 0.4640641212 |
| Skewness | -0.2901935875 |
| Sum | 8507.571289 |
| Variance | 0.557821691 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 11 | 0.3% |
| 0.6931471825 | 8 | 0.2% |
| 1.791759491 | 8 | 0.2% |
| 0.3465735912 | 7 | 0.2% |
| 1.098612309 | 7 | 0.2% |
| 2.302585125 | 5 | 0.2% |
| 1.039720774 | 5 | 0.2% |
| 1.059351325 | 4 | 0.1% |
| 0.6212266684 | 4 | 0.1% |
| 1.902217627 | 4 | 0.1% |
| Other values (3097) | 3177 |
| Value | Count | Frequency (%) |
| 0 | 11 | |
| 0.1732867956 | 2 | 0.1% |
| 0.2746530771 | 1 | < 0.1% |
| 0.3465735912 | 7 | |
| 0.3662041128 | 1 | < 0.1% |
| 0.4315260947 | 1 | < 0.1% |
| 0.4479398727 | 2 | 0.1% |
| 0.4620981216 | 2 | 0.1% |
| 0.4864775538 | 1 | < 0.1% |
| 0.5296756625 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5.407171726 | 1 | |
| 5.147494316 | 1 | |
| 5.002599239 | 1 | |
| 4.908172607 | 1 | |
| 4.865320206 | 1 | |
| 4.84916687 | 1 | |
| 4.815023422 | 1 | |
| 4.782802582 | 1 | |
| 4.753828049 | 1 | |
| 4.733560562 | 1 |
| Distinct | 725 |
|---|---|
| Distinct (%) | 22.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.03125 |
| Minimum | 2.455078125 |
|---|---|
| Maximum | 10.7734375 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.5 KiB |
Quantile statistics
| Minimum | 2.455078125 |
|---|---|
| 5-th percentile | 6.601367188 |
| Q1 | 7.56640625 |
| median | 8.0625 |
| Q3 | 8.580078125 |
| 95-th percentile | 9.328515625 |
| Maximum | 10.7734375 |
| Range | 8.318359375 |
| Interquartile range (IQR) | 1.013671875 |
Descriptive statistics
| Standard deviation | 0.87890625 |
|---|---|
| Coefficient of variation (CV) | 0.1094360352 |
| Kurtosis | 2.97265625 |
| Mean | 8.03125 |
| Median Absolute Deviation (MAD) | 0.5078125 |
| Skewness | -0.7622070312 |
| Sum | 26016 |
| Variance | 0.7724609375 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8.015625 | 19 | 0.6% |
| 8.234375 | 18 | 0.6% |
| 8.0625 | 18 | 0.6% |
| 8.171875 | 18 | 0.6% |
| 8.6796875 | 17 | 0.5% |
| 8.125 | 17 | 0.5% |
| 8.140625 | 17 | 0.5% |
| 8.3359375 | 17 | 0.5% |
| 8.390625 | 17 | 0.5% |
| 8.0546875 | 17 | 0.5% |
| Other values (715) | 3065 |
| Value | Count | Frequency (%) |
| 2.455078125 | 1 | |
| 2.849609375 | 1 | |
| 2.861328125 | 1 | |
| 2.9765625 | 1 | |
| 3.03515625 | 1 | |
| 3.8203125 | 1 | |
| 4.0703125 | 1 | |
| 4.08984375 | 1 | |
| 4.21484375 | 1 | |
| 4.36328125 | 1 |
| Value | Count | Frequency (%) |
| 10.7734375 | 1 | |
| 10.578125 | 1 | |
| 10.546875 | 1 | |
| 10.5390625 | 1 | |
| 10.5234375 | 1 | |
| 10.4765625 | 1 | |
| 10.4609375 | 1 | |
| 10.40625 | 1 | |
| 10.390625 | 1 | |
| 10.375 | 1 |
| Distinct | 53 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.2 |
| Minimum | 1 |
|---|---|
| Maximum | 60 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 12 |
| Q3 | 21 |
| 95-th percentile | 36.05 |
| Maximum | 60 |
| Range | 59 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.47972157 |
|---|---|
| Coefficient of variation (CV) | 0.7552448404 |
| Kurtosis | 0.6164804356 |
| Mean | 15.2 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.05163755 |
| Sum | 49248 |
| Variance | 131.7840074 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 522 | |
| 8 | 389 | |
| 12 | 382 | |
| 16 | 238 | 7.3% |
| 20 | 200 | 6.2% |
| 24 | 197 | 6.1% |
| 28 | 151 | 4.7% |
| 3 | 146 | 4.5% |
| 32 | 117 | 3.6% |
| 6 | 98 | 3.0% |
| Other values (43) | 800 |
| Value | Count | Frequency (%) |
| 1 | 50 | 1.5% |
| 2 | 49 | 1.5% |
| 3 | 146 | 4.5% |
| 4 | 522 | |
| 5 | 30 | 0.9% |
| 6 | 98 | 3.0% |
| 7 | 20 | 0.6% |
| 8 | 389 | |
| 9 | 71 | 2.2% |
| 10 | 15 | 0.5% |
| Value | Count | Frequency (%) |
| 60 | 2 | 0.1% |
| 56 | 7 | 0.2% |
| 54 | 1 | < 0.1% |
| 52 | 18 | |
| 51 | 1 | < 0.1% |
| 49 | 2 | 0.1% |
| 48 | 26 | |
| 47 | 3 | 0.1% |
| 45 | 1 | < 0.1% |
| 44 | 39 |
last_login
Date
| Distinct | 368 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 25.4 KiB |
| Minimum | 2015-02-19 00:00:00 |
|---|---|
| Maximum | 2017-02-28 00:00:00 |
registration_duration
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 629 |
|---|---|
| Distinct (%) | 19.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 405.6981481 |
| Minimum | 22 |
|---|---|
| Maximum | 819 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 25.4 KiB |
Quantile statistics
| Minimum | 22 |
|---|---|
| 5-th percentile | 90 |
| Q1 | 243 |
| median | 424 |
| Q3 | 547 |
| 95-th percentile | 728.05 |
| Maximum | 819 |
| Range | 797 |
| Interquartile range (IQR) | 304 |
Descriptive statistics
| Standard deviation | 187.5153054 |
|---|---|
| Coefficient of variation (CV) | 0.4622039963 |
| Kurtosis | -0.7962752704 |
| Mean | 405.6981481 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | -0.01974052938 |
| Sum | 1314462 |
| Variance | 35161.98975 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 425 | 80 | 2.5% |
| 517 | 79 | 2.4% |
| 516 | 69 | 2.1% |
| 486 | 68 | 2.1% |
| 394 | 66 | 2.0% |
| 547 | 62 | 1.9% |
| 242 | 61 | 1.9% |
| 424 | 57 | 1.8% |
| 211 | 56 | 1.7% |
| 578 | 56 | 1.7% |
| Other values (619) | 2586 |
| Value | Count | Frequency (%) |
| 22 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 30 | 4 | 0.1% |
| 31 | 1 | < 0.1% |
| 33 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 35 | 1 | < 0.1% |
| 56 | 1 | < 0.1% |
| 58 | 31 | |
| 59 | 5 | 0.2% |
| Value | Count | Frequency (%) |
| 819 | 1 | < 0.1% |
| 814 | 1 | < 0.1% |
| 813 | 1 | < 0.1% |
| 810 | 3 | |
| 809 | 1 | < 0.1% |
| 806 | 1 | < 0.1% |
| 805 | 2 | |
| 803 | 2 | |
| 801 | 1 | < 0.1% |
| 799 | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | msno | city | bd | gender | registered_via | registration_init_time | is_churn | total_payment_channels | change_in_payment_methods | payment_plan_days_mean | change_in_plan | plan_list_price_mean | actual_amount_paid_mean | is_auto_renew_mean | is_autorenew_change_flag | transaction_date_min | transaction_date_max | total_transactions | membership_expire_date_max | is_cancel_mean | is_cancel_change_flag | discount_mean | is_discount_mean | is_discount_max | amt_per_day_mean | membership_duration_mean | more_than_30_sum | num_25 | num_50 | num_75 | num_985 | num_100 | num_unq | total_secs | login_freq | last_login | registration_duration | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 252737 | T4TLe/jOIP0/Bg9kOKR3rd19XVZDIHlVzvS3DhpweIk= | 1 | 6.3 | 2 | 4 | 2016-05-22 | 1 | 9 | 2 | 27.444444 | 2 | 132.444444 | 132.444444 | 0.000000 | 0 | 2016-05-23 | 2017-01-04 | 9 | 2017-02-03 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.414815 | 41.222222 | 6 | 1.013038 | 0.568968 | 0.198042 | 0.099021 | 1.223618 | 2.076368 | 7.078125 | 14 | 2017-02-25 | 257 |
| 1 | 80833 | 3twUh3ugQEnQyGAyOxT4uPhpMht2EPW1vl6/k7J+RdI= | 8 | 26.0 | 1 | 3 | 2015-04-11 | 1 | 15 | 1 | 41.000000 | 2 | 198.666667 | 198.666667 | 0.000000 | 0 | 2015-04-11 | 2016-08-05 | 15 | 2017-02-17 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.941197 | 41.533333 | 2 | 1.583790 | 0.359393 | 0.337993 | 0.537676 | 2.452048 | 3.038424 | 8.257812 | 44 | 2017-01-21 | 678 |
| 2 | 89564 | /1X44AKG3S5AoBAJeokIkqLvgRaz+h5ElPncLqWnWys= | 1 | 6.3 | 2 | 7 | 2015-12-01 | 0 | 14 | 1 | 30.000000 | 1 | 149.000000 | 149.000000 | 1.000000 | 1 | 2015-12-01 | 2017-02-28 | 14 | 2017-03-31 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 30.285714 | 7 | 1.382377 | 0.353117 | 0.269348 | 0.440205 | 3.848993 | 3.863208 | 9.406250 | 27 | 2017-01-27 | 486 |
| 3 | 141070 | 1Ufg2Ep/dzom8G0hN+0UWbmxpRPFrGt4D4Vh2yd4pOA= | 1 | 6.3 | 2 | 7 | 2016-09-10 | 0 | 7 | 1 | 30.000000 | 1 | 142.000000 | 142.000000 | 1.000000 | 1 | 2016-09-10 | 2017-02-03 | 7 | 2017-03-02 | 0.142857 | 1 | 0.0 | 0.0 | 0 | 4.733333 | 25.571429 | 3 | 1.378806 | 0.207076 | 0.057762 | 0.057762 | 1.865789 | 2.257427 | 7.589844 | 12 | 2017-01-19 | 173 |
| 4 | 182169 | ZozytlgZZhHBVCTHGug8CxREhiV9QpS+TJ5e+z06gVA= | 1 | 6.3 | 2 | 7 | 2017-01-06 | 0 | 2 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.000000 | 1 | 2017-01-06 | 2017-02-05 | 2 | 2017-03-05 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 29.000000 | 0 | 1.163490 | 0.346574 | 0.000000 | 0.274653 | 0.866434 | 1.599232 | 6.941406 | 4 | 2017-01-26 | 58 |
| 5 | 30877 | fsnsbXZaA/6BEIkHAEXt3yv0IKmO2BT7X6OVSryjLwE= | 18 | 36.0 | 1 | 4 | 2015-12-21 | 0 | 15 | 1 | 30.000000 | 1 | 149.000000 | 149.000000 | 1.000000 | 1 | 2015-12-22 | 2017-02-22 | 15 | 2017-03-23 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 31.400000 | 13 | 0.762862 | 0.221265 | 0.279372 | 0.246718 | 3.508522 | 3.509402 | 9.062500 | 36 | 2017-02-27 | 458 |
| 6 | 178732 | Pu+GJ7D/z/RdQdtkEC1FliAwgfqf4Lj2R+Yy8zpxIPI= | 13 | 21.0 | 1 | 4 | 2016-04-18 | 0 | 9 | 2 | 30.000000 | 1 | 149.000000 | 149.000000 | 0.777778 | 1 | 2016-05-13 | 2017-02-08 | 9 | 2017-03-07 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.966667 | 29.444444 | 0 | 1.986556 | 0.822406 | 0.374467 | 0.000000 | 0.995693 | 2.659642 | 7.160156 | 8 | 2016-12-28 | 323 |
| 7 | 106440 | 4qn9IK9A4x98g5rvJzA/zs22i/cXKVnH2UxKIIohsmE= | 4 | 19.0 | 0 | 7 | 2016-05-27 | 0 | 10 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.000000 | 1 | 2016-05-27 | 2017-02-27 | 10 | 2017-03-27 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.400000 | 6 | 1.577559 | 0.588908 | 0.294268 | 0.357281 | 2.165143 | 2.795527 | 7.910156 | 22 | 2017-02-28 | 304 |
| 8 | 234719 | 7Ch66cFMKjzoFmwEael1cZmL96xEXu1deuaISvbLeU4= | 1 | 6.3 | 2 | 7 | 2016-07-14 | 0 | 8 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.000000 | 1 | 2016-07-14 | 2017-02-14 | 8 | 2017-03-14 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 3.300000 | 30.375000 | 5 | 2.077086 | 0.361296 | 0.173287 | 0.000000 | 1.612202 | 2.362854 | 7.074219 | 8 | 2017-02-06 | 243 |
| 9 | 274386 | 5dpAfmav4ClRi5GKyLvGya+izdDXwwr/4OZt9gxmDlU= | 1 | 6.3 | 2 | 4 | 2015-10-18 | 0 | 4 | 1 | 71.250000 | 2 | 335.250000 | 335.250000 | 0.000000 | 0 | 2016-05-20 | 2017-02-04 | 4 | 2017-03-06 | 0.000000 | 0 | 0.0 | 0.0 | 0 | 4.871154 | 71.250000 | 1 | 0.403842 | 0.216608 | 0.068663 | 0.169253 | 2.933867 | 3.001538 | 8.445312 | 16 | 2016-12-25 | 505 |
Last rows
| df_index | msno | city | bd | gender | registered_via | registration_init_time | is_churn | total_payment_channels | change_in_payment_methods | payment_plan_days_mean | change_in_plan | plan_list_price_mean | actual_amount_paid_mean | is_auto_renew_mean | is_autorenew_change_flag | transaction_date_min | transaction_date_max | total_transactions | membership_expire_date_max | is_cancel_mean | is_cancel_change_flag | discount_mean | is_discount_mean | is_discount_max | amt_per_day_mean | membership_duration_mean | more_than_30_sum | num_25 | num_50 | num_75 | num_985 | num_100 | num_unq | total_secs | login_freq | last_login | registration_duration | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3230 | 187413 | 79Q/WeLodGSQlPUcu6wsDyjVJGnSPXv6RMc9wGcTiR8= | 1 | 6.3 | 2 | 7 | 2016-07-21 | 0 | 8 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.00 | 1 | 2016-07-21 | 2017-02-21 | 8 | 2017-03-21 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.300000 | 30.375000 | 5 | 0.668388 | 0.000000 | 0.223970 | 0.086643 | 2.241992 | 2.597821 | 7.785156 | 8 | 2017-01-24 | 243 |
| 3231 | 304085 | tgeVcKKWT6J9gkjx2JU55hxxUH88+LEFoQH86/cZ1D8= | 1 | 6.3 | 2 | 7 | 2015-08-24 | 0 | 19 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.00 | 1 | 2015-08-24 | 2017-02-24 | 19 | 2017-03-24 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.300000 | 30.421053 | 11 | 0.963329 | 0.447496 | 0.415871 | 0.420436 | 2.544532 | 2.918861 | 8.195312 | 28 | 2017-01-24 | 578 |
| 3232 | 322144 | MGaWfjFD/r30hDkROFyUVWi855UH0ztytdvDL5V7Pvk= | 1 | 6.3 | 2 | 7 | 2015-08-15 | 0 | 19 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.00 | 1 | 2015-08-15 | 2017-02-15 | 19 | 2017-03-15 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.300000 | 30.421053 | 11 | 0.510015 | 0.205902 | 0.057762 | 0.028881 | 2.798397 | 2.899035 | 8.281250 | 24 | 2017-01-02 | 578 |
| 3233 | 263776 | fQJki8ybPbMCQNFQPNBW+sFLR8+pBELeX7rlkqrTLbc= | 1 | 6.3 | 2 | 4 | 2016-06-11 | 0 | 4 | 2 | 24.250000 | 2 | 96.750000 | 96.750000 | 0.75 | 1 | 2016-11-18 | 2017-02-13 | 4 | 2017-03-12 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.225000 | 23.500000 | 0 | 0.274653 | 0.000000 | 0.000000 | 0.000000 | 2.769765 | 2.557477 | 8.171875 | 4 | 2017-02-02 | 274 |
| 3234 | 288974 | vg+QL04sOCSObeXU69EJiHO2NImLRK67ahyuBpVzFeA= | 1 | 6.3 | 2 | 7 | 2016-10-20 | 0 | 5 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.00 | 1 | 2016-10-20 | 2017-02-20 | 5 | 2017-03-20 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.300000 | 30.200000 | 3 | 1.919466 | 0.748933 | 0.173287 | 0.519860 | 2.692794 | 3.100821 | 8.523438 | 4 | 2017-01-19 | 151 |
| 3235 | 86597 | GGYWYQvviAQ9W94VQflD8wEyb6WKNExntEJipz6mv8g= | 6 | 35.0 | 0 | 7 | 2015-04-11 | 0 | 23 | 1 | 28.695652 | 2 | 132.956522 | 138.565217 | 1.00 | 1 | 2015-04-11 | 2017-02-11 | 23 | 2017-03-11 | 0.000000 | 0 | -5.608696 | 0.0 | 0 | 4.431884 | 30.434783 | 13 | 1.293096 | 0.402168 | 0.385608 | 0.350725 | 4.184368 | 4.235391 | 9.773438 | 56 | 2017-02-03 | 700 |
| 3236 | 207550 | 5sSNrAqwo38OR9C+ONc8KIw87taIUG/qmCfT/UDGb6E= | 5 | 6.3 | 2 | 4 | 2016-10-08 | 0 | 6 | 2 | 30.000000 | 1 | 174.833333 | 174.833333 | 1.00 | 1 | 2016-10-09 | 2017-02-13 | 6 | 2017-03-12 | 0.166667 | 1 | 0.000000 | 0.0 | 0 | 5.827778 | 25.833333 | 4 | 1.674776 | 0.807731 | 0.587438 | 0.374984 | 2.208150 | 2.763800 | 8.070312 | 12 | 2017-02-13 | 155 |
| 3237 | 92226 | 15vWvbCMoL85Av7HzcT6j2dPhle8xr9Hb64NwqrlcUU= | 1 | 6.3 | 2 | 7 | 2016-03-27 | 0 | 13 | 1 | 30.000000 | 1 | 147.461538 | 147.461538 | 1.00 | 1 | 2016-03-27 | 2017-02-05 | 13 | 2017-03-04 | 0.076923 | 1 | 0.000000 | 0.0 | 0 | 4.915385 | 27.923077 | 6 | 0.687469 | 0.374777 | 0.144519 | 0.124245 | 2.058531 | 2.280118 | 7.636719 | 20 | 2017-02-17 | 342 |
| 3238 | 81542 | RTPKmf59dlNdzpxKu/qrtOqDQ74He06Xf5BC/rMz3DU= | 1 | 6.3 | 2 | 7 | 2015-09-25 | 0 | 18 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.00 | 1 | 2015-09-25 | 2017-02-25 | 18 | 2017-03-25 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.300000 | 30.388889 | 10 | 1.699414 | 0.404618 | 0.363569 | 0.612881 | 2.202865 | 2.791239 | 8.015625 | 16 | 2016-12-26 | 547 |
| 3239 | 319970 | 3WzQnhLLIR6Rt/DEYHEsgjxiJHoTudo5SXkgftKbyc0= | 1 | 6.3 | 2 | 7 | 2016-02-06 | 0 | 13 | 1 | 30.000000 | 1 | 99.000000 | 99.000000 | 1.00 | 1 | 2016-02-06 | 2017-02-06 | 13 | 2017-03-06 | 0.000000 | 0 | 0.000000 | 0.0 | 0 | 3.300000 | 30.307692 | 7 | 0.384555 | 0.046210 | 0.092420 | 0.000000 | 2.497438 | 1.816807 | 8.000000 | 15 | 2017-02-14 | 394 |